There is a wide variety of scenarios that are challenging and time consuming to handle utilizing traditional database comparison and synchronization tools and for which xSQL Builder would be an ideal solution. Following are just some of those scenarios that software developers and publishers face:
- Synchronizing multiple client databases with one master database;
- No access to client databases that must be upgraded;
- Master database is not reachable from the client machines;
- Various clients may be using different version of the application and database (different database schemas);
- Need to run custom T-SQL scripts before and/or after synchronizing the client's database to the master database;
- Need to generate ready-to-deploy executable packages for all your client databases automatically
- Wish to generate a package for your .NET deployment solution or other setup and deployment utilities
- Need to customize the deployment package before generating
- Must be notified via email when the database deployment package fails to complete all the tasks
- Must log all operations that are performed on the client machine when the package is deployed
xSQL Builder has been designed to addresses all these issues by providing a standard interface, simple and yet flexible enough to allow you to fine-tune it to your specific needs.